'use strict'

const pg = require('pg');

let psql = new pg.Pool({
    host:'127.0.0.1',
    port: 5432,
    user:'jinshiyun',
    password:'xyd20010201',
    database:'jinshiyun',
    //最大客户端连接数量
    max:8
})

;(async ()=>{
    let sqltext = `insert into `
            + `content(id, title, detail, add_time, update_time)`
            + ` values ($1, $2, $3, $4, $5)`

    let tm = Date.now()

    let ret = await psql.query(sqltext, [
        `${tm}`,
        `${Math.random()}`,
        '测试内容',
        tm,
        tm
    ])

    let ret2 =await psql.query(`select * from content`)

    psql.end()

    console.log(ret,ret2)

})();